pp108 : Bsfconfig for JDBC

Bsfconfig for JDBC
This topic contains the structure of the bsfconfig file used for JDBC driver.


Using this code, create a bsfconfig file. 

<configurations>
    <configuration
        htmfile="/cordys/cpc/bsf/developer/content/bsftabpage.htm" implementation="com.cordys.cpc.bsf.connector.BsfConnector">
        <component name="Rule Engine">
            <ruleAudit>false</ruleAudit>
            <publishAudit>false</publishAudit>
            <threadPoolSize>5</threadPoolSize>
            <maxDispatcherQueueSize>50000</maxDispatcherQueueSize>
        </component>
        <component name="Rule Repository ConnectionPool">
            <server>servername</server>
            <userName>sa</userName>
            <password>YzByZHlz</password>
            <defaultDatabase>databasename</defaultDatabase>
            <minimumReadConnections>1</minimumReadConnections>
            <maximumReadConnections>5</maximumReadConnections>
            <minimumWriteConnections>1</minimumWriteConnections>
            <maximumWriteConnections>5</maximumWriteConnections>
            <queryCacheSize>50</queryCacheSize>
            <queryCacheRefreshInterval>3600</queryCacheRefreshInterval>
            <cursorCacheSize>50</cursorCacheSize>
            <cursorCacheRefreshInterval>3600</cursorCacheRefreshInterval>
            <driverName>JDBC</driverName>
            <jdbcDriver>FQCN of JDBC Driver class</jdbcDriver>
            <connectionString>JDBC connection string url</connectionString>
            <xmlEncoding>true</xmlEncoding>
            <multibyte>false</multibyte>
            <refreshInterval>3600</refreshInterval>
        </component>
        <ruleEnabled>true</ruleEnabled>
        <autoCleanup>false</autoCleanup>
        <auditEnabled>off</auditEnabled>
        <initializeDB>true</initializeDB>
        <initializeEIS>false</initializeEIS>
        <customInitializer>FQCN of class implementing IOnBsfConnector interface</customInitializer>
        <bsfuser>cn=demousr,cn=organizational users,o=system,cn=cordys,cn=cordysinstancename,o=vanenburg.com</bsfuser>
        <component name="WS-AppServerConnectionPool">
            <server>servername</server>
            <userName>sa</userName>
            <password>YzByZHlz</password>
            <defaultDatabase>databasename</defaultDatabase>
            <operatingsystem>windows</operatingsystem>
            <maximumReadConnections>3</maximumReadConnections>
            <maximumWriteConnections>7</maximumWriteConnections>
            <queryCacheSize>50</queryCacheSize>
            <queryCacheRefreshInterval>3600</queryCacheRefreshInterval>
            <cursorCacheSize>50</cursorCacheSize>
            <cursorCacheRefreshInterval>3600</cursorCacheRefreshInterval>
            <driverName>JDBC</driverName>
            <jdbcDriver>FQCN of JDBC Driver class</jdbcDriver>
            <connectionString>JDBC connection string url</connectionString>
            <xmlEncoding>true</xmlEncoding>
            <multibyte>false</multibyte>
            <readEmptyStringAsNull>true</readEmptyStringAsNull>
            <writeEmptyStringAsNull>true</writeEmptyStringAsNull>
            <auditInfo/>
        </component>
    </configuration>
</configurations>

Attachments: